Tabela Infection

Definicja tabeli Infection

Name

Infection

Code

Infection

Comment

 


Lista kolumn tabeli Infection

Name

Code

InfectionID

InfectionID

BirthStageID

BirthStageID

DeceaseIdentificationID

DeceaseIdentificationID

InfClinicalProcessID

InfClinicalProcessID

InfectionClassID

InfectionClassID

InfectionTypeID

InfectionTypeID

InfectionQualificationID

InfectionQualificationID

PatogenID

PatogenID

MaterialID

MaterialID

Active

Active

Confirmation

Confirmation

StartDT

StartDT

StopDT

StopDT

HBD

HBD

APGAR

APGAR

Puerperium

Puerperium

BirthWeight

BirthWeight

InfectionOccured

InfectionOccured

Comments

Comments

DateValue

DateValue

InfectionClassDescr

InfectionClassDescr

InfectionTypeDescr

InfectionTypeDescr

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

AdditionalInfo

AdditionalInfo

CollectionDT

CollectionDT

Colonization

Colonization

ActionIsolation

ActionIsolation

ActionReminder

ActionReminder

ActionAntibiotic

ActionAntibiotic

APAdditionalInfo

APAdditionalInfo

APInfectionTypeID

APInfectionTypeID

InfectionQualificationDescr

InfectionQualificationDescr

SourceOrgUnitID

SourceOrgUnitID

AuthPersonID

AuthPersonID

AuthComment

AuthComment

DaysBeforeInfection

DaysBeforeInfection


Kolumna InfectionID tabeli Infection

Definicja kolumny InfectionID tabeli Infection

Name

InfectionID

Code

InfectionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BirthStageID tabeli Infection

Definicja kolumny BirthStageID tabeli Infection

Name

BirthStageID

Code

BirthStageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DeceaseIdentificationID tabeli Infection

Definicja kolumny DeceaseIdentificationID tabeli Infection

Name

DeceaseIdentificationID

Code

DeceaseIdentificationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfClinicalProcessID tabeli Infection

Definicja kolumny InfClinicalProcessID tabeli Infection

Name

InfClinicalProcessID

Code

InfClinicalProcessID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionClassID tabeli Infection

Definicja kolumny InfectionClassID tabeli Infection

Name

InfectionClassID

Code

InfectionClassID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionTypeID tabeli Infection

Definicja kolumny InfectionTypeID tabeli Infection

Name

InfectionTypeID

Code

InfectionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionQualificationID tabeli Infection

Definicja kolumny InfectionQualificationID tabeli Infection

Name

InfectionQualificationID

Code

InfectionQualificationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatogenID tabeli Infection

Definicja kolumny PatogenID tabeli Infection

Name

PatogenID

Code

PatogenID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MaterialID tabeli Infection

Definicja kolumny MaterialID tabeli Infection

Name

MaterialID

Code

MaterialID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Infection

Definicja kolumny Active tabeli Infection

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Confirmation tabeli Infection

Definicja kolumny Confirmation tabeli Infection

Name

Confirmation

Code

Confirmation

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Infection

Definicja kolumny StartDT tabeli Infection

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Infection

Definicja kolumny StopDT tabeli Infection

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna HBD tabeli Infection

Definicja kolumny HBD tabeli Infection

Name

HBD

Code

HBD

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna APGAR tabeli Infection

Definicja kolumny APGAR tabeli Infection

Name

APGAR

Code

APGAR

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Puerperium tabeli Infection

Definicja kolumny Puerperium tabeli Infection

Name

Puerperium

Code

Puerperium

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BirthWeight tabeli Infection

Definicja kolumny BirthWeight tabeli Infection

Name

BirthWeight

Code

BirthWeight

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionOccured tabeli Infection

Definicja kolumny InfectionOccured tabeli Infection

Name

InfectionOccured

Code

InfectionOccured

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Comments tabeli Infection

Definicja kolumny Comments tabeli Infection

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna DateValue tabeli Infection

Definicja kolumny DateValue tabeli Infection

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna InfectionClassDescr tabeli Infection

Definicja kolumny InfectionClassDescr tabeli Infection

Name

InfectionClassDescr

Code

InfectionClassDescr

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InfectionTypeDescr tabeli Infection

Definicja kolumny InfectionTypeDescr tabeli Infection

Name

InfectionTypeDescr

Code

InfectionTypeDescr

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli Infection

Definicja kolumny InsertDate tabeli Infection

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli Infection

Definicja kolumny InsertingPerson tabeli Infection

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli Infection

Definicja kolumny LastModifiedDT tabeli Infection

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli Infection

Definicja kolumny LastModifiedPerson tabeli Infection

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdditionalInfo tabeli Infection

Definicja kolumny AdditionalInfo tabeli Infection

Name

AdditionalInfo

Code

AdditionalInfo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Infekcje - informacje dodatkowe


Kolumna CollectionDT tabeli Infection

Definicja kolumny CollectionDT tabeli Infection

Name

CollectionDT

Code

CollectionDT

Data Type

DATE

Mandatory

No

Comment

Data pobrania próbki


Kolumna Colonization tabeli Infection

Definicja kolumny Colonization tabeli Infection

Name

Colonization

Code

Colonization

Data Type

NUMBER(5)

Mandatory

No

Comment

'Kolonizacja' lub 'Rodzaj zakazenia'


Kolumna ActionIsolation tabeli Infection

Definicja kolumny ActionIsolation tabeli Infection

Name

ActionIsolation

Code

ActionIsolation

Data Type

NUMBER(5)

Mandatory

No

Comment

Izolacja


Kolumna ActionReminder tabeli Infection

Definicja kolumny ActionReminder tabeli Infection

Name

ActionReminder

Code

ActionReminder

Data Type

NUMBER(5)

Mandatory

No

Comment

Kohartacja


Kolumna ActionAntibiotic tabeli Infection

Definicja kolumny ActionAntibiotic tabeli Infection

Name

ActionAntibiotic

Code

ActionAntibiotic

Data Type

NUMBER(5)

Mandatory

No

Comment

Antybiotyk


Kolumna APAdditionalInfo tabeli Infection

Definicja kolumny APAdditionalInfo tabeli Infection

Name

APAdditionalInfo

Code

APAdditionalInfo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Informacje dodatkowe dot. patogenu alarmowego


Kolumna APInfectionTypeID tabeli Infection

Definicja kolumny APInfectionTypeID tabeli Infection

Name

APInfectionTypeID

Code

APInfectionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Rodzaj zakazenia.

NOTE: W bazie juz znajduje sie informacja o rodzaju zakazenia, ale klient CSK chce rozrózniac te pola.


Kolumna InfectionQualificationDescr tabeli Infection

Definicja kolumny InfectionQualificationDescr tabeli Infection

Name

InfectionQualificationDescr

Code

InfectionQualificationDescr

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Przechowywanie kwalifikacji zakazenia, której nie ma w slowniku InfectionQualification


Kolumna SourceOrgUnitID tabeli Infection

Definicja kolumny SourceOrgUnitID tabeli Infection

Name

SourceOrgUnitID

Code

SourceOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pole trzyma informacje o szpitalu, w którym nastapilo zakazenie, jesli wybrano zródlo zakazenia "Z innego szpitala".


Kolumna AuthPersonID tabeli Infection

Definicja kolumny AuthPersonID tabeli Infection

Name

AuthPersonID

Code

AuthPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Idenfikator osoby autoryzujacej zakazenie


Kolumna AuthComment tabeli Infection

Definicja kolumny AuthComment tabeli Infection

Name

AuthComment

Code

AuthComment

Data Type

VARCHAR2(100)

Mandatory

No

Comment

Komentarz osoby autoryzujacej zakazenie


Kolumna DaysBeforeInfection tabeli Infection

Definicja kolumny DaysBeforeInfection tabeli Infection

Name

DaysBeforeInfection

Code

DaysBeforeInfection

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc dni przed wystapieniem zakazenia


Lista kluczy tabeli Infection

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Infection

Definicja klucza Identifier_1 tabeli Infection

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment